﻿<?xml version="1.0" encoding="utf-8" ?>
<healthcheck>
  <name>QueryInformation</name>
  <description>Queries</description>
  <returntype>simplegrid</returntype>
  <query>
    <name>QueryInformation</name>
    <description>List of Queries</description>
    <namespace>site</namespace>
    <type>WQL</type>
    <queryID>1</queryID>
    <sql>
      SELECT * FROM SMS_Query where QueryID like '@@SITECODE@@%'
    </sql>
    <field name="QueryID" description="QueryID" props="" queryID="1" bestfit="true" />
    <field name="Name" description="Name" props="" queryID="1" bestfit="true" />
    <field name="Comments" description="Comments" props="" queryID="1" bestfit="true" />
    <field name="LimitToCollectionID" description="Limit to" props="" queryID="1" bestfit="true" />
    <field name="TargetClassName" description="Target" props="" queryID="1" bestfit="true" />
    <field name="Expression" description="SQL" props="" queryID="1" bestfit="false" />
  </query>
</healthcheck>